﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_Flow_UpdateStyleDescription_V2]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_Flow_UpdateStyleDescription_V2];
GO
CREATE PROCEDURE [dbo].[sproc_Flow_UpdateStyleDescription_V2]
    @DescriptionID int,
    -- @StyleID int,
    -- @FieldName nvarchar(100),
    @FieldDescription nvarchar(100),
    @Judged bit,
    @MultiLine bit,    
    @Height int,
    @Width int,
    @Position int,
    @Example nvarchar(100)
AS
BEGIN
SET NOCOUNT ON;

UPDATE dbo.uds_flow_Style_Description 
    SET
        -- Style_ID = @StyleID ,
        -- Field_Name	= @FieldName,
        Field_Description	= @FieldDescription,
        Judged		= @Judged,
        MultiLine	= @MultiLine,
        Height		= @Height,
        Width		= @Width ,
        [Position]	= @Position,
        Example		= @Example
    WHERE Description_ID = @DescriptionID;
IF ( @@ROWCOUNT = 0 )
	RETURN -1;  -- Not found

RETURN 0; -- OK

END
GO